/*
 Navicat Premium Data Transfer

 Source Server         : 2h8g
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : 129.211.37.55:3305
 Source Schema         : kai

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 04/02/2020 10:26:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for account_logs
-- ----------------------------
DROP TABLE IF EXISTS `account_logs`;
CREATE TABLE `account_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL COMMENT '小类型。',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  `number` decimal(20,2) DEFAULT '0.00',
  `big_type` varchar(255) DEFAULT NULL COMMENT '大类型， 拼车，购物，其他。',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `dui` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for admin_has_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_has_permissions`;
CREATE TABLE `admin_has_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of admin_has_permissions
-- ----------------------------
BEGIN;
INSERT INTO `admin_has_permissions` VALUES (295, 20, 29, '2020-02-03 15:35:13', '2020-02-03 15:35:13');
INSERT INTO `admin_has_permissions` VALUES (296, 20, 28, '2020-02-03 15:35:13', '2020-02-03 15:35:13');
INSERT INTO `admin_has_permissions` VALUES (297, 20, 27, '2020-02-03 15:35:13', '2020-02-03 15:35:13');
INSERT INTO `admin_has_permissions` VALUES (298, 20, 1, '2020-02-03 15:35:13', '2020-02-03 15:35:13');
INSERT INTO `admin_has_permissions` VALUES (303, 21, 32, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (304, 21, 27, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (305, 21, 1, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (306, 21, 33, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (307, 21, 32, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (308, 21, 27, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (309, 21, 1, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (310, 21, 34, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (311, 21, 32, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (312, 21, 27, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (313, 21, 1, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (314, 21, 35, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (315, 21, 32, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (316, 21, 27, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
INSERT INTO `admin_has_permissions` VALUES (317, 21, 1, '2020-02-04 09:07:58', '2020-02-04 09:07:58');
COMMIT;

-- ----------------------------
-- Table structure for admin_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_permissions`;
CREATE TABLE `admin_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT '0',
  `type` varchar(255) DEFAULT NULL COMMENT '备注：1菜单，2按钮',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL COMMENT '前端页面路径',
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of admin_permissions
-- ----------------------------
BEGIN;
INSERT INTO `admin_permissions` VALUES (1, '后台菜单', '/', 0, '1', '2019-12-16 17:03:01', '2019-12-16 17:03:01', NULL, 'nested');
INSERT INTO `admin_permissions` VALUES (2, '权限管理', '/auth', 1, '1', '2019-12-16 17:03:01', '2019-12-16 17:03:01', '/auth', 'nested');
INSERT INTO `admin_permissions` VALUES (14, '管理员', 'admins', 2, '1', '2019-12-17 23:59:26', '2019-12-17 23:59:26', 'admins', NULL);
INSERT INTO `admin_permissions` VALUES (15, '权限列表', 'permissions', 2, '1', '2019-12-17 23:59:43', '2019-12-17 23:59:43', 'permissions', NULL);
INSERT INTO `admin_permissions` VALUES (16, '添加-管理员', 'add-admin', 14, '2', '2019-12-18 00:38:07', '2019-12-18 00:38:07', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (17, '添加-权限', 'add-permission', 15, '2', '2019-12-18 00:38:35', '2019-12-18 00:38:35', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (18, '编辑-权限', 'edit-permission', 15, '2', '2019-12-18 00:38:59', '2019-12-18 00:39:37', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (19, '删除-权限', 'delete-permission', 15, '2', '2019-12-18 00:39:26', '2019-12-18 00:39:26', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (20, '编辑-管理员', 'edit-admin', 14, '2', '2019-12-18 01:13:38', '2019-12-18 01:13:38', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (21, '删除-管理员', 'delete-admin', 14, '2', '2019-12-18 01:13:53', '2019-12-19 20:07:30', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (22, '分配权限', 'distribution-permission', 14, '2', '2020-01-21 09:34:20', '2020-01-21 09:34:51', '', NULL);
INSERT INTO `admin_permissions` VALUES (23, '用户管理', 'users', 1, '1', '2020-01-30 18:55:37', '2020-01-30 18:56:09', '/user', NULL);
INSERT INTO `admin_permissions` VALUES (24, '用户设置', 'set', 23, '1', '2020-01-30 18:56:36', '2020-01-30 19:01:44', 'set', NULL);
INSERT INTO `admin_permissions` VALUES (25, '用户列表', 'users_index', 23, '1', '2020-01-30 18:57:06', '2020-01-30 19:43:45', 'users', NULL);
INSERT INTO `admin_permissions` VALUES (26, '用户编辑', 'user_index_edit', 25, '2', '2020-01-30 18:58:29', '2020-01-30 18:58:29', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (27, '公告管理', 'notify', 1, '1', '2020-01-31 19:36:29', '2020-01-31 19:36:29', '/notify', NULL);
INSERT INTO `admin_permissions` VALUES (28, '公告分类', 'notify_classify', 27, '1', '2020-01-31 19:37:03', '2020-01-31 19:37:03', 'classify', NULL);
INSERT INTO `admin_permissions` VALUES (29, '添加-公告分类', 'add_notify_classify', 28, '2', '2020-01-31 19:47:38', '2020-02-01 11:50:00', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (30, '编辑-公告分类', 'edit_notify_classify', 28, '2', '2020-01-31 19:48:29', '2020-02-01 11:50:13', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (31, '删除-公告分类', 'delete_notify_classify', 28, '2', '2020-01-31 19:49:55', '2020-02-01 11:53:19', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (32, '公告列表', 'notifys', 27, '1', '2020-02-01 11:59:50', '2020-02-04 09:22:47', 'notifys', NULL);
INSERT INTO `admin_permissions` VALUES (33, '添加-公告列表', 'add_notify', 32, '2', '2020-02-01 12:00:17', '2020-02-01 12:00:17', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (34, '编辑-公告列表', 'edit_notify', 32, '2', '2020-02-01 12:00:32', '2020-02-01 12:00:32', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (35, '删除-公告列表', 'delete_notify', 32, '2', '2020-02-01 12:00:52', '2020-02-01 12:00:52', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (36, 'test', 'test', 16, '1', '2020-02-03 14:12:01', '2020-02-03 14:12:01', 'test', NULL);
INSERT INTO `admin_permissions` VALUES (37, 'test2', 'test2', 15, '1', '2020-02-03 14:12:33', '2020-02-03 14:12:33', 'test2', NULL);
INSERT INTO `admin_permissions` VALUES (38, 'test2222', 'test2222', 37, '1', '2020-02-03 14:12:49', '2020-02-03 14:12:49', 'test2222', NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_display` int(1) DEFAULT '0',
  `avar` varchar(255) DEFAULT NULL,
  `last_token` varchar(2555) DEFAULT NULL,
  `last_ip` varchar(255) DEFAULT NULL,
  `last_count` int(11) DEFAULT '0',
  `last_at` timestamp NULL DEFAULT NULL,
  `permissions` text,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of admin_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_users` VALUES (1, NULL, 'admin', '8bf1fe528f6998834ecf4d61e7530168', '2019-12-14 13:31:43', '2020-02-03 19:44:42', 0, 'http://blog.jiabaoleshop.com/images/home/default_head_img.gif', 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOlwvXC95emIuamlhYmFvbGVzaG9wLmNvbVwvYXBpXC92MVwvYXV0aFwvbG9naW4iLCJpYXQiOjE1Nzc2NzY1NzEsImV4cCI6MTU3NzY3NjU3MSwibmJmIjoxNTc3Njc2NTcxLCJqdGkiOiJnQkhxWU5RemFBS0lPRUdQIiwic3ViIjoxLCJwcnYiOiJiNzVhMGI1NzFjNDYzZmQ2NDIwMmI1MDUwOWUxMWRmZjA1MzVmZDI1IiwiZ3VhcmQiOiJhZG1pbiJ9.I_GAwrcuOz4RAfGRkgO-Sd7jcYoirpYFFZpyZDEIXfQ', '129.211.37.55', 326, '2020-02-03 19:44:42', NULL);
INSERT INTO `admin_users` VALUES (20, NULL, 'test', '8bf1fe528f6998834ecf4d61e7530168', '2019-12-18 00:04:47', '2020-02-03 15:35:13', 0, NULL, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOlwvXC95emIuamlhYmFvbGVzaG9wLmNvbVwvYXBpXC92MVwvYXV0aFwvbG9naW4iLCJpYXQiOjE1NzY2Mzc4MDUsImV4cCI6MTU3NjYzNzgwNSwibmJmIjoxNTc2NjM3ODA1LCJqdGkiOiJrNGE1c1VrQ1JlMGhkRWlPIiwic3ViIjoyMCwicHJ2IjoiYjc1YTBiNTcxYzQ2M2ZkNjQyMDJiNTA1MDllMTFkZmYwNTM1ZmQyNSIsImd1YXJkIjoiYWRtaW4ifQ.30SzWwvuoZNU-zrWALSvctREK8xRWcioeKe04k-HU3A', '129.211.37.55', 28, '2020-02-03 15:31:32', '[29]');
INSERT INTO `admin_users` VALUES (21, 'aaa', 'aaa', '8bf1fe528f6998834ecf4d61e7530168', '2020-02-04 09:05:23', '2020-02-04 09:07:58', 0, NULL, NULL, '129.211.37.55', 1, '2020-02-04 09:06:50', '[32,33,34,35]');
COMMIT;

-- ----------------------------
-- Table structure for configs
-- ----------------------------
DROP TABLE IF EXISTS `configs`;
CREATE TABLE `configs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `config` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of configs
-- ----------------------------
BEGIN;
INSERT INTO `configs` VALUES (9, 'zhusu', '{\"name\":\"kk\",\"logo\":\"http://image.cdn.jiabaoleshop.com/FgyeVEtFKRm0EebML3Rqpr9YtWsT\"}', NULL, '2019-12-20 01:11:20', NULL, 'bianmin');
INSERT INTO `configs` VALUES (10, 'tianqi', '{\"name\":\"天气查询\",\"logo\":\"http://image.cdn.jiabaoleshop.com/Fu--RCdlRDRSmJI65pfxhGmhVT9n\",\"pingtai\":\"聚合\",\"key\":\"11\",\"siyue\":\"22\"}', NULL, '2019-12-20 01:12:32', NULL, 'bianmin');
INSERT INTO `configs` VALUES (11, 'sms', '{\"name\":\"\\u77ed\\u4fe1\\u5b9d\",\"api\":\"http:\\/\\/www.smsbao.com\\/\",\"user\":\"16712114189\",\"pass\":\"Lijingjing123!\",\"sign\":\"[\\u77ed\\u4fe1\\u5b9d]\",\"phone\":\"13243362307\"}', NULL, '2020-01-30 13:23:49', '短信配置', 'system');
INSERT INTO `configs` VALUES (12, 'image', '{\"type\":\"2\",\"name\":\"\\u4e03\\u725b\\u4e91\",\"access_key\":\"JVoVC6YwVaqzKtLqkuDyUS05Fzmw0yMMMMKz1DnN\",\"secret_key\":\"cbywgMPBA1ea3Sh5CiCRG8a0tgWR1wbTk84qf19V\",\"bucket\":\"liyzb\",\"domain\":\"http:\\/\\/q2oucg72c.bkt.clouddn.com\\/\"}', NULL, '2020-01-30 14:31:05', NULL, 'system');
INSERT INTO `configs` VALUES (13, 'app_set', '{\"name\":\"appSet\",\"logo\":\"http:\\/\\/image.cdn.jiabaoleshop.com\\/FkykJm-OE32gX6tt_ocE5jCdxBl_\",\"url\":\"kjii\"}', NULL, '2020-01-30 17:48:24', NULL, 'system');
INSERT INTO `configs` VALUES (14, 'user_set', '{\"path\":\"http:\\/\\/image.cdn.jiabaoleshop.com\\/FmE8tpe-UmJS9JUVtoHAtvBxCHTi\",\"reg_ok\":\"2\"}', NULL, '2020-01-30 18:51:09', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for notify_classifys
-- ----------------------------
DROP TABLE IF EXISTS `notify_classifys`;
CREATE TABLE `notify_classifys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of notify_classifys
-- ----------------------------
BEGIN;
INSERT INTO `notify_classifys` VALUES (2, '热门', 'http://image.cdn.jiabaoleshop.com/Fs07-P_eTRC4BmuRMSgt8AEwRMNw', NULL, '2020-01-31 14:13:24', '2020-02-03 15:24:16');
INSERT INTO `notify_classifys` VALUES (3, 'hha', 'http://image.cdn.jiabaoleshop.com/FgyeVEtFKRm0EebML3Rqpr9YtWsT', NULL, '2020-01-31 15:05:47', '2020-01-31 15:10:43');
COMMIT;

-- ----------------------------
-- Table structure for notifys
-- ----------------------------
DROP TABLE IF EXISTS `notifys`;
CREATE TABLE `notifys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `contents` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `time` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of notifys
-- ----------------------------
BEGIN;
INSERT INTO `notifys` VALUES (1, 'jidshu', 'huhu', '<p>huhu</p>', 2, NULL, '2020-01-31 15:08:53', '2020-02-03 14:16:02', 'http://image.cdn.jiabaoleshop.com/FgyeVEtFKRm0EebML3Rqpr9YtWsT');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `is_real` tinyint(1) DEFAULT '0',
  `sex` int(1) DEFAULT '0' COMMENT '0 未知， 1， 男， 2女',
  `birth` timestamp NULL DEFAULT NULL,
  `open_id` varchar(255) DEFAULT NULL,
  `is_display` int(1) DEFAULT '0',
  `invitation_code` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `avatar` varchar(2555) DEFAULT NULL,
  `pay_password` int(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `last_ip` varchar(255) DEFAULT NULL,
  `last_count` int(11) DEFAULT '0',
  `last_at` timestamp NULL DEFAULT NULL,
  `balance` decimal(20,2) unsigned DEFAULT '0.00',
  `ti_phone` varchar(255) DEFAULT NULL COMMENT '提现手机号',
  `ti_name` varchar(255) DEFAULT NULL COMMENT '提现到账姓名',
  `user_level` int(1) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (1, 0, 'aak', '188', 1, 0, '2019-12-18 19:54:16', '1', 0, '8888', '2019-12-18 19:54:23', '2020-02-03 17:00:25', 'http://blog.jiabaoleshop.com/images/home/default_head_img.gif', 123456, '123456', NULL, 0, '2019-12-18 19:54:41', 0.00, 'li', 'li11', 0);
INSERT INTO `users` VALUES (7, 1, '167****4189', '16712114189', 0, 0, NULL, NULL, 1, 'bzsdct', '2019-12-24 20:32:25', '2020-02-03 14:56:34', 'http://image.cdn.jiabaoleshop.com/FqqggYtY_3Dy-HG6KBOlny8IGQ5A', NULL, '$2y$10$LBgF3UekNbvziG/EiB/WJOndfXeeNNIYCgyf7J2yIGjPoD7Kc9HQC', '223.88.64.229', 63, NULL, 0.00, NULL, NULL, 0);
INSERT INTO `users` VALUES (8, 1, '167****4181', '16712114181', 0, 0, NULL, NULL, 1, 'oyehfe', '2019-12-24 20:34:45', '2020-02-03 14:13:06', 'http://image.cdn.jiabaoleshop.com/FqqggYtY_3Dy-HG6KBOlny8IGQ5A', NULL, '$2y$10$Kv0sTjXx.QYiDhSM1gW.eObv5vZUa7t5My6CcXk7KH4nxCBW.h2hy', '61.158.152.1', 1, NULL, 0.00, NULL, NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
